<%-- ExMobi JSP文件，注释和取消快捷键统一为Ctrl+/ 多行注释为Ctrl+Shift+/ --%>
<%@ page language="java" import="java.util.*,org.json.*"
 contentType="application/json; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ include file="/client/adapt.jsp"%>
<%@ include file="properties.jsp"%>
<%
     String outstr="";
     String username= aa.req.getParameter("username");
     JSONObject oj = new JSONObject();
     JSONArray jlst = new JSONArray();
     String sqlstr ="";
     Object[] param = new Object[]{};
     if (username.trim().equals("")){
          sqlstr = "select * from tb_user_info";
     }else{
          sqlstr = "select * from tb_user_info where username =? ";
          param = new Object[]{username} ;
     }
     List<TableRow> list = aa.db.query("blm", sqlstr, param); 
     for(TableRow row:list){
    	 jlst.put(new JSONObject(row.toJson())) ;
     }
	  oj.put("json", jlst);
	  oj.put("ret", "ok");
   System.out.println(oj.toString());
   String recall = aa.req.getParameter("callback");
   outstr = jsonp(recall,oj.toString());
   out.print(outstr);
%>
